Variant functions are inefficient by nature, and should not be used with strings when string-specific versions, denoted by a $
at the
end of the name, are available.
This rule flags instances of these functions:
Left()
, Mid()
, Right()
, Chr()
, ChrW()
, UCase()
, LCase()
,
LTrim()
, RTrim()
, Trim()
, Space()
, String()
, Format()
,
Hex()
, Oct(),
Str()
, Error
Noncompliant code example
TrimString = Trim(TestString)
Compliant solution
TrimString = Trim$(TestString)